Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	14244
Missing cells	2396
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 MiB
Average record size in memory	104.0 B

Variable types

DateTime	1
Numeric	12

Alerts

`flow_avg` is highly overall correlated with `flow_max` and 4 other fields	High correlation
`flow_max` is highly overall correlated with `flow_avg` and 4 other fields	High correlation
`flow_min` is highly overall correlated with `flow_avg` and 4 other fields	High correlation
`level_avg` is highly overall correlated with `flow_avg` and 4 other fields	High correlation
`level_max` is highly overall correlated with `flow_avg` and 4 other fields	High correlation
`level_min` is highly overall correlated with `flow_avg` and 4 other fields	High correlation
`water_temp_avg` is highly overall correlated with `water_temp_max` and 1 other fields	High correlation
`water_temp_max` is highly overall correlated with `water_temp_avg` and 1 other fields	High correlation
`water_temp_min` is highly overall correlated with `water_temp_avg` and 1 other fields	High correlation
`concent_solids` has 230 (1.6%) missing values	Missing
`water_temp_avg` has 722 (5.1%) missing values	Missing
`water_temp_max` has 722 (5.1%) missing values	Missing
`water_temp_min` has 722 (5.1%) missing values	Missing
`date` has unique values	Unique

Reproduction

Analysis started	2025-02-20 14:57:51.795653
Analysis finished	2025-02-20 14:57:58.468305
Duration	6.67 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

date
Date

UNIQUE

Distinct	14244
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	222.6 KiB

Minimum	1985-01-01 00:00:00
Maximum	2023-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

flow_avg
Real number (ℝ)

HIGH CORRELATION

Distinct	1117
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.692099

Minimum	9.06
Maximum	926
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	9.06
5-th percentile	20.4
Q1	31.8
median	49.7
Q3	76.6
95-th percentile	149
Maximum	926
Range	916.94
Interquartile range (IQR)	44.8

Descriptive statistics

Standard deviation	50.042658
Coefficient of variation (CV)	0.7982291
Kurtosis	33.459985
Mean	62.692099
Median Absolute Deviation (MAD)	20.6
Skewness	4.0447695
Sum	892986.26
Variance	2504.2676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104	48	0.3%
107	47	0.3%
101	43	0.3%
102	42	0.3%
28.6	41	0.3%
109	40	0.3%
106	39	0.3%
105	39	0.3%
26	38	0.3%
103	37	0.3%
Other values (1107)	13830	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.06	1	< 0.1%
10.5	1	< 0.1%
11.5	1	< 0.1%
11.7	1	< 0.1%
13	1	< 0.1%
13.3	1	< 0.1%
13.6	1	< 0.1%
13.7	1	< 0.1%
13.9	3	< 0.1%
14.1	1	< 0.1%

Value	Count	Frequency (%)
926	1	< 0.1%
786	1	< 0.1%
767	1	< 0.1%
757	1	< 0.1%
747	1	< 0.1%
717	1	< 0.1%
707	1	< 0.1%
648	1	< 0.1%
568	1	< 0.1%
561	1	< 0.1%

flow_max
Real number (ℝ)

HIGH CORRELATION

Distinct	1156
Distinct (%)	8.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.704325

Minimum	11.8
Maximum	1050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	11.8
5-th percentile	23.1
Q1	38.6
median	58.45
Q3	88.1
95-th percentile	177
Maximum	1050
Range	1038.2
Interquartile range (IQR)	49.5

Descriptive statistics

Standard deviation	59.017005
Coefficient of variation (CV)	0.80072648
Kurtosis	29.528257
Mean	73.704325
Median Absolute Deviation (MAD)	23.15
Skewness	3.9029255
Sum	1049844.4
Variance	3483.0068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	68	0.5%
103	64	0.4%
101	61	0.4%
102	60	0.4%
105	57	0.4%
111	54	0.4%
108	54	0.4%
106	53	0.4%
110	47	0.3%
104	46	0.3%
Other values (1146)	13680	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.8	1	< 0.1%
14.5	1	< 0.1%
14.7	2	< 0.1%
14.8	1	< 0.1%
14.9	1	< 0.1%
15	2	< 0.1%
15.1	5	< 0.1%
15.2	4	< 0.1%
15.3	4	< 0.1%
15.4	2	< 0.1%

Value	Count	Frequency (%)
1050	1	< 0.1%
912	1	< 0.1%
830	1	< 0.1%
827	1	< 0.1%
814	1	< 0.1%
766	1	< 0.1%
761	1	< 0.1%
758	1	< 0.1%
715	1	< 0.1%
709	1	< 0.1%

flow_min
Real number (ℝ)

HIGH CORRELATION

Distinct	1102
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.726115

Minimum	6.02
Maximum	809
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	6.02
5-th percentile	18
Q1	26.2
median	40.7
Q3	65.4
95-th percentile	124
Maximum	809
Range	802.98
Interquartile range (IQR)	39.2

Descriptive statistics

Standard deviation	42.688642
Coefficient of variation (CV)	0.80962996
Kurtosis	38.325011
Mean	52.726115
Median Absolute Deviation (MAD)	16.9
Skewness	4.2311651
Sum	751030.78
Variance	1822.3202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23	68	0.5%
25	50	0.4%
23.6	50	0.4%
22.8	49	0.3%
24.3	49	0.3%
24.1	49	0.3%
24.8	46	0.3%
25.5	46	0.3%
21.2	45	0.3%
22.1	45	0.3%
Other values (1092)	13747	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.02	1	< 0.1%
6.49	1	< 0.1%
7.62	1	< 0.1%
7.66	1	< 0.1%
8.07	1	< 0.1%
8.65	1	< 0.1%
8.85	1	< 0.1%
8.9	1	< 0.1%
9.15	1	< 0.1%
9.23	1	< 0.1%

Value	Count	Frequency (%)
809	1	< 0.1%
751	1	< 0.1%
733	1	< 0.1%
713	1	< 0.1%
649	1	< 0.1%
634	1	< 0.1%
521	1	< 0.1%
505	1	< 0.1%
502	1	< 0.1%
475	1	< 0.1%

level_avg
Real number (ℝ)

HIGH CORRELATION

Distinct	268
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.802373

Minimum	19
Maximum	495
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	19
5-th percentile	42
Q1	60
median	79
Q3	100
95-th percentile	149
Maximum	495
Range	476
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	35.857536
Coefficient of variation (CV)	0.42283647
Kurtosis	9.8565196
Mean	84.802373
Median Absolute Deviation (MAD)	20
Skewness	2.0714917
Sum	1207925
Variance	1285.7629
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	214	1.5%
58	212	1.5%
75	211	1.5%
74	209	1.5%
72	208	1.5%
79	202	1.4%
55	202	1.4%
86	201	1.4%
54	197	1.4%
87	197	1.4%
Other values (258)	12191	85.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	1	< 0.1%
22	1	< 0.1%
24	1	< 0.1%
25	1	< 0.1%
27	9	0.1%
28	7	< 0.1%
29	11	0.1%
30	12	0.1%
31	7	< 0.1%
32	15	0.1%

Value	Count	Frequency (%)
495	1	< 0.1%
450	1	< 0.1%
442	1	< 0.1%
432	1	< 0.1%
430	1	< 0.1%
414	2	< 0.1%
387	1	< 0.1%
352	1	< 0.1%
350	1	< 0.1%
343	1	< 0.1%

level_max
Real number (ℝ)

HIGH CORRELATION

Distinct	288
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	93.586633

Minimum	25
Maximum	542
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	25
5-th percentile	48
Q1	68
median	87
Q3	108
95-th percentile	165
Maximum	542
Range	517
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	39.50154
Coefficient of variation (CV)	0.42208528
Kurtosis	10.172091
Mean	93.586633
Median Absolute Deviation (MAD)	20
Skewness	2.1956188
Sum	1333048
Variance	1560.3717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	228	1.6%
82	218	1.5%
91	215	1.5%
90	211	1.5%
88	206	1.4%
84	206	1.4%
87	205	1.4%
70	200	1.4%
85	199	1.4%
74	194	1.4%
Other values (278)	12162	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	1	< 0.1%
28	6	< 0.1%
29	3	< 0.1%
30	4	< 0.1%
31	9	0.1%
32	7	< 0.1%
33	17	0.1%
34	18	0.1%
35	26	0.2%
36	39	0.3%

Value	Count	Frequency (%)
542	1	< 0.1%
491	1	< 0.1%
469	1	< 0.1%
467	1	< 0.1%
453	1	< 0.1%
439	1	< 0.1%
436	1	< 0.1%
432	1	< 0.1%
414	1	< 0.1%
411	1	< 0.1%

level_min
Real number (ℝ)

HIGH CORRELATION

Distinct	249
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76.510601

Minimum	11
Maximum	451
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	11
5-th percentile	37
Q1	53
median	71
Q3	92
95-th percentile	135
Maximum	451
Range	440
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	33.055575
Coefficient of variation (CV)	0.43203915
Kurtosis	9.2296606
Mean	76.510601
Median Absolute Deviation (MAD)	19
Skewness	1.950734
Sum	1089817
Variance	1092.671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48	253	1.8%
52	244	1.7%
46	240	1.7%
51	234	1.6%
56	233	1.6%
47	233	1.6%
53	232	1.6%
54	226	1.6%
55	224	1.6%
49	217	1.5%
Other values (239)	11908	83.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	3	< 0.1%
20	3	< 0.1%
21	1	< 0.1%
22	3	< 0.1%
23	7	< 0.1%

Value	Count	Frequency (%)
451	1	< 0.1%
434	1	< 0.1%
425	1	< 0.1%
413	1	< 0.1%
389	1	< 0.1%
380	1	< 0.1%
334	1	< 0.1%
326	1	< 0.1%
324	1	< 0.1%
312	1	< 0.1%

concent_solids
Real number (ℝ)

MISSING

Distinct	3929
Distinct (%)	28.0%
Missing	230
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%
Mean	18.621997

Minimum	0.35
Maximum	1292.14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	0.35
5-th percentile	2.7165
Q1	6.7
median	11
Q3	17.7575
95-th percentile	51.2105
Maximum	1292.14
Range	1291.79
Interquartile range (IQR)	11.0575

Descriptive statistics

Standard deviation	39.882114
Coefficient of variation (CV)	2.1416668
Kurtosis	224.74159
Mean	18.621997
Median Absolute Deviation (MAD)	5.03
Skewness	12.196003
Sum	260968.67
Variance	1590.583
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	45	0.3%
4.44	25	0.2%
7	21	0.1%
12	21	0.1%
8.43	20	0.1%
7.05	20	0.1%
9.96	18	0.1%
4.82	18	0.1%
8	18	0.1%
11	18	0.1%
Other values (3919)	13790	96.8%
(Missing)	230	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.35	1	< 0.1%
0.42	1	< 0.1%
0.45	1	< 0.1%
0.46	4	< 0.1%
0.48	2	< 0.1%
0.49	3	< 0.1%
0.5	2	< 0.1%
0.51	1	< 0.1%
0.52	1	< 0.1%
0.53	3	< 0.1%

Value	Count	Frequency (%)
1292.14	1	< 0.1%
992.69	1	< 0.1%
885.4	1	< 0.1%
862.21	1	< 0.1%
847.2	1	< 0.1%
755.56	1	< 0.1%
744.36	1	< 0.1%
713.79	1	< 0.1%
700.65	1	< 0.1%
693.32	1	< 0.1%

water_temp_avg
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	216
Distinct (%)	1.6%
Missing	722
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	9.967135

Minimum	0.2
Maximum	21.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	0.2
5-th percentile	3.2
Q1	5.5
median	9.7
Q3	14.2
95-th percentile	17.7
Maximum	21.8
Range	21.6
Interquartile range (IQR)	8.7

Descriptive statistics

Standard deviation	4.859061
Coefficient of variation (CV)	0.48750829
Kurtosis	-1.1640994
Mean	9.967135
Median Absolute Deviation (MAD)	4.3
Skewness	0.16769617
Sum	134775.6
Variance	23.610474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	205	1.4%
5	172	1.2%
4	157	1.1%
5.2	152	1.1%
4.4	149	1.0%
5.8	145	1.0%
4.6	145	1.0%
4.8	142	1.0%
6.2	137	1.0%
3.8	136	1.0%
Other values (206)	11982	84.1%
(Missing)	722	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.3	3	< 0.1%
0.4	2	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	6	< 0.1%
0.9	6	< 0.1%
1	10	0.1%
1.1	9	0.1%
1.2	11	0.1%

Value	Count	Frequency (%)
21.8	1	< 0.1%
21.7	3	< 0.1%
21.6	1	< 0.1%
21.5	3	< 0.1%
21.4	3	< 0.1%
21.3	1	< 0.1%
21.2	6	< 0.1%
21.1	5	< 0.1%
21	4	< 0.1%
20.9	3	< 0.1%

water_temp_max
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	220
Distinct (%)	1.6%
Missing	722
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	10.278849

Minimum	0.5
Maximum	22.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	222.6 KiB

Quantile statistics

Minimum	0.5
5-th percentile	3.3
Q1	5.8
median	10
Q3	14.5
95-th percentile	18.3
Maximum	22.4
Range	21.9
Interquartile range (IQR)	8.7

Descriptive statistics

Standard deviation	4.9867413
Coefficient of variation (CV)	0.48514587
Kurtosis	-1.1379955
Mean	10.278849
Median Absolute Deviation (MAD)	4.3
Skewness	0.18518921
Sum	138990.6
Variance	24.867589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	192	1.3%
5	170	1.2%
4.8	166	1.2%
5.2	161	1.1%
6	152	1.1%
4.4	149	1.0%
6.2	148	1.0%
5.8	147	1.0%
4.6	142	1.0%
4	141	1.0%
Other values (210)	11954	83.9%
(Missing)	722	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	3	< 0.1%
0.6	1	< 0.1%
0.7	1	< 0.1%
0.8	4	< 0.1%
0.9	1	< 0.1%
1	8	0.1%
1.1	6	< 0.1%
1.2	11	0.1%
1.3	4	< 0.1%
1.4	13	0.1%

Value	Count	Frequency (%)
22.4	1	< 0.1%
22.3	2	< 0.1%
22.2	2	< 0.1%
22.1	2	< 0.1%
22	2	< 0.1%
21.9	2	< 0.1%
21.8	3	< 0.1%
21.7	4	< 0.1%
21.6	4	< 0.1%
21.5	6	< 0.1%

water_temp_min
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	213
Distinct (%)	1.6%
Missing	722
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	9.6619287

Minimum	-0.1
Maximum	21.4
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	222.6 KiB

Quantile statistics

Minimum	-0.1
5-th percentile	3
Q1	5.3
median	9.4
Q3	13.8
95-th percentile	17.195
Maximum	21.4
Range	21.5
Interquartile range (IQR)	8.5

Descriptive statistics

Standard deviation	4.7583886
Coefficient of variation (CV)	0.49248848
Kurtosis	-1.166763
Mean	9.6619287
Median Absolute Deviation (MAD)	4.2
Skewness	0.1635044
Sum	130648.6
Variance	22.642262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.2	213	1.5%
4	175	1.2%
5	169	1.2%
3.8	154	1.1%
4.8	151	1.1%
4.4	148	1.0%
14.8	146	1.0%
6	144	1.0%
5.2	140	1.0%
5.6	140	1.0%
Other values (203)	11942	83.8%
(Missing)	722	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.1	2	< 0.1%
0.1	2	< 0.1%
0.2	3	< 0.1%
0.3	1	< 0.1%
0.4	2	< 0.1%
0.5	4	< 0.1%
0.6	5	< 0.1%
0.7	3	< 0.1%
0.8	6	< 0.1%
0.9	6	< 0.1%

Value	Count	Frequency (%)
21.4	3	< 0.1%
21.2	6	< 0.1%
21.1	1	< 0.1%
21	4	< 0.1%
20.9	2	< 0.1%
20.8	2	< 0.1%
20.6	5	< 0.1%
20.5	4	< 0.1%
20.4	8	0.1%
20.3	3	< 0.1%

year
Real number (ℝ)

Distinct	39
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2004

Minimum	1985
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.9 KiB

Quantile statistics

Minimum	1985
5-th percentile	1986
Q1	1994
median	2004
Q3	2014
95-th percentile	2022
Maximum	2023
Range	38
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11.254462
Coefficient of variation (CV)	0.0056159992
Kurtosis	-1.2015639
Mean	2004
Median Absolute Deviation (MAD)	10
Skewness	0
Sum	28544976
Variance	126.66292
Monotonicity	Increasing

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
2004	366	2.6%
1992	366	2.6%
2012	366	2.6%
2000	366	2.6%
1996	366	2.6%
2016	366	2.6%
2020	366	2.6%
1988	366	2.6%
2008	366	2.6%
2019	365	2.6%
Other values (29)	10585	74.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1985	365	2.6%
1986	365	2.6%
1987	365	2.6%
1988	366	2.6%
1989	365	2.6%
1990	365	2.6%
1991	365	2.6%
1992	366	2.6%
1993	365	2.6%
1994	365	2.6%

Value	Count	Frequency (%)
2023	365	2.6%
2022	365	2.6%
2021	365	2.6%
2020	366	2.6%
2019	365	2.6%
2018	365	2.6%
2017	365	2.6%
2016	366	2.6%
2015	365	2.6%
2014	365	2.6%

month
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5231676

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4487589
Coefficient of variation (CV)	0.52869389
Kurtosis	-1.2079823
Mean	6.5231676
Median Absolute Deviation (MAD)	3
Skewness	-0.0093842176
Sum	92916
Variance	11.893938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	1209	8.5%
3	1209	8.5%
5	1209	8.5%
7	1209	8.5%
8	1209	8.5%
10	1209	8.5%
12	1209	8.5%
4	1170	8.2%
6	1170	8.2%
9	1170	8.2%
Other values (2)	2271	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1209	8.5%
2	1101	7.7%
3	1209	8.5%
4	1170	8.2%
5	1209	8.5%
6	1170	8.2%
7	1209	8.5%
8	1209	8.5%
9	1170	8.2%
10	1209	8.5%

Value	Count	Frequency (%)
12	1209	8.5%
11	1170	8.2%
10	1209	8.5%
9	1170	8.2%
8	1209	8.5%
7	1209	8.5%
6	1170	8.2%
5	1209	8.5%
4	1170	8.2%
3	1209	8.5%

Auto

Heatmap
Table

	concent_solids	flow_avg	flow_max	flow_min	level_avg	level_max	level_min	month	water_temp_avg	water_temp_max	water_temp_min	year
concent_solids	1.000	0.439	0.457	0.403	0.325	0.352	0.282	-0.052	0.104	0.104	0.105	-0.185
flow_avg	0.439	1.000	0.984	0.977	0.899	0.906	0.849	0.020	0.282	0.284	0.279	-0.026
flow_max	0.457	0.984	1.000	0.939	0.867	0.907	0.797	0.023	0.291	0.292	0.291	-0.074
flow_min	0.403	0.977	0.939	1.000	0.901	0.882	0.893	0.014	0.265	0.270	0.261	0.027
level_avg	0.325	0.899	0.867	0.901	1.000	0.981	0.977	0.022	0.298	0.304	0.291	0.213
level_max	0.352	0.906	0.907	0.882	0.981	1.000	0.934	0.027	0.313	0.316	0.309	0.145
level_min	0.282	0.849	0.797	0.893	0.977	0.934	1.000	0.015	0.275	0.284	0.265	0.284
month	-0.052	0.020	0.023	0.014	0.022	0.027	0.015	1.000	0.346	0.336	0.356	0.000
water_temp_avg	0.104	0.282	0.291	0.265	0.298	0.313	0.275	0.346	1.000	0.997	0.997	0.073
water_temp_max	0.104	0.284	0.292	0.270	0.304	0.316	0.284	0.336	0.997	1.000	0.988	0.123
water_temp_min	0.105	0.279	0.291	0.261	0.291	0.309	0.265	0.356	0.997	0.988	1.000	0.019
year	-0.185	-0.026	-0.074	0.027	0.213	0.145	0.284	0.000	0.073	0.123	0.019	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	date	flow_avg	flow_max	flow_min	level_avg	level_max	level_min	concent_solids	water_temp_avg	water_temp_max	water_temp_min	year	month
9558	1985-01-01	18.0	19.9	16.8	38.0	41.0	36.0	5.31	3.8	3.8	3.8	1985	1
9559	1985-01-02	17.1	21.3	15.5	37.0	43.0	34.0	5.28	2.5	2.5	2.5	1985	1
9560	1985-01-03	24.1	32.4	20.6	47.0	57.0	42.0	5.54	2.4	2.4	2.4	1985	1
9561	1985-01-04	23.5	29.8	18.6	46.0	54.0	39.0	6.98	2.3	2.3	2.3	1985	1
9562	1985-01-05	23.7	36.8	20.6	46.0	62.0	42.0	8.54	2.1	2.1	2.1	1985	1
9563	1985-01-06	20.7	24.3	16.2	42.0	47.0	35.0	10.11	1.8	1.8	1.8	1985	1
9564	1985-01-07	19.7	27.3	16.2	40.0	51.0	35.0	11.68	1.1	1.1	1.1	1985	1
9565	1985-01-08	31.7	42.6	19.9	56.0	68.0	41.0	13.25	1.2	1.2	1.2	1985	1
9566	1985-01-09	39.5	50.6	33.3	65.0	76.0	58.0	14.82	1.2	1.2	1.2	1985	1
9567	1985-01-10	36.8	47.5	26.6	62.0	73.0	50.0	16.04	1.1	1.1	1.1	1985	1

	date	flow_avg	flow_max	flow_min	level_avg	level_max	level_min	concent_solids	water_temp_avg	water_temp_max	water_temp_min	year	month
23792	2023-12-22	152.0	193.0	101.0	169.0	193.0	138.0	11.69	5.8	6.0	5.6	2023	12
23793	2023-12-23	180.0	186.0	173.0	185.0	189.0	182.0	12.21	5.8	5.9	5.6	2023	12
23794	2023-12-24	167.0	179.0	149.0	178.0	185.0	168.0	11.05	5.9	6.2	5.7	2023	12
23795	2023-12-25	142.0	149.0	131.0	163.0	168.0	157.0	10.35	6.4	6.6	6.2	2023	12
23796	2023-12-26	128.0	133.0	122.0	155.0	158.0	151.0	9.99	5.9	6.4	5.7	2023	12
23797	2023-12-27	125.0	128.0	114.0	153.0	155.0	146.0	9.72	5.9	6.0	5.5	2023	12
23798	2023-12-28	122.0	130.0	112.0	151.0	156.0	145.0	9.56	5.3	5.6	5.1	2023	12
23799	2023-12-29	111.0	115.0	106.0	144.0	147.0	141.0	9.46	5.7	6.0	5.4	2023	12
23800	2023-12-30	107.0	114.0	91.9	142.0	146.0	131.0	9.40	6.0	6.2	5.7	2023	12
23801	2023-12-31	82.6	90.0	79.5	126.0	131.0	124.0	9.26	5.4	5.7	5.1	2023	12

Overview

Variables

Interactions

Correlations

Missing values

Sample